Release 10.1A: OpenEdge Data Management:
SQL Development


Connecting from a Java application using a data source

You can connect to a database from a Java application using a data source. There are required and optional settings when connecting using a data source. Table 2–2 lists the settings.

Table 2–2: Data source settings
Required settings
Optional settings
oeds.setServerName(“host”);
oeds.setServiceName(“name”);
oeds.setDatabaseName(“name”);
oeds.setDescription(“text”);
oeds.setPortNumber(number);
oeds.setDataSourceName(“name”);
oeds.setUser(“user”);
oeds.setStatementCacheSize(cache_size);
oeds.setPassword(“password”);
oeds.setDefaultSchema(“name”);

Note that the oeds in the settings signifies an OpenEdge data source.

To connect using a data source, specify the connection type (connection, pooled, or XA) and specify the settings.


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095